Water-based transanal irrigation system